home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-20
/
miles.zip
/
MILES.TXT
< prev
next >
Wrap
Text File
|
1990-10-17
|
1KB
|
43 lines
MILES!
THIS SPREADSHEET CAME ABOUT DUE TO THE NEED IN OUR COMPANY TO COMPUTE
A FREIGHT RATE BETWEEN OUR MANUFACTURING FACILITY AND THE DESTINATION
AIRPORT.WE BUILD AIRCRAFT HANGARS SO OUR CUSTOMERS ARE ALWAYS ON AIRPORTS.
THE MATH WAS FOUND IN THE BASIC CODE FOR A PROGRAM CALLED AIRMILES AND FULL
CREDIT IS DUE .
INSERT LATITUDE AND LONGITUDE IN THE FOLLOWING FORM:
N32-41.6 BECOMES 32.416
A VERY GOOD SOURCE OF COORDINATES IS IN A LITTLE BOOK CALLED
AC-U-KWIK .IT IS AN AIRMANS REFERENCE GUIDE AND IS AVAILABLE FROM
402-978-7709.
THE PROGRAM CAN EASILY BE MODIFIED AND LINKED TO OTHER SHEETS TO RETURN
FREIGHT RATES ECT.
ZIP FILE SHOULD CONTAIN TWO FILES:
MILES.TXT :ASCII DOCUMENTATION
MILES.XLS :EXCEL SPREADSHEET
FEEL FREE TO MODIFY OR COPY AND FREELY DISTRIBUTE THIS SHE
GREAT CIRCLE MILES
DG=360/(PI()*2)
DAB=SIN(LAT1)*SIN(LAT2)+COS(LAT1)*COS(LAT2)*COS(LONG1-LONG2)
FNACOS=ATAN(SQRT(1-V1*V1)/V1)*DGWHERE V1
IS RESULT OF VECTOR DAB
DIST IS ABS(FNACOS(DAB))
DIST X 69.133 FOR STATUTE
" X 60.0576 FOR NAUT
AFTER IMPUTING LAT AND LONG IN FORM: 85.254
DIVIDE EACH BY DG TO GET USABLE FORM I.E LAT1
HAVE FUN!
VAN THURSTON JR.
404-227-8520
TEK* BUILDING SYSTEMS